Oracle 10g introduced Data Masking to hide sensitive data.  It is primarily designed to be used when copying data from production to non-production environments.  Oracle 12c Data Redaction can be used to partially obscure or completely hide sensitive data when the information is displayed on a screen or a printed report.  This presentation will first…

On version 12c Oracle introduced several new features to allow Adaptive optimizations: Adaptive Plans and Adaptive Statistics. After a quick presentation of concepts, this session will explore the interaction of these features with other performance management techniques using examples, like SPM and SQL profiles. Attendees will get an updated picture of tools available to troubleshoot…

Original Broadcast: 11.20.13 Join Anuj Mohan as he delves into several of the most important features of Oracle 12c Container Databases.In his 1 hour presentation, Anuj will speak on the following: * CDB/PDB Introduction * PDB - Explanation of Value (EOV) * CDB/PDB Concepts * Shared / Exclusive components * Accessing CDB's/PDB's * Quick overview: migration…

Consolidating database servers can go a long way toward streamlining your IT, but it still leaves you with several different databases to back up, upgrade and monitor. In this session, you will learn how Oracle multitenant architecture can free you from riding herd over multiple databases, so you can focus on the strategic initiatives that drive…

Oracle DBA, consultant, and Oracle University instructor Jim Czuprynski will demonstrate how to leverage several new features of Oracle Database Release 12cR1 that dramatically decrease the time it takes to back up Oracle 12c databases, as well as perform recovery at much more granular levels. Jim will also explore the incredible speed at which Oracle…

There is increasing pressure to improve system availability to try to provide 5X9 service. This 99.999% availability requirement means a system can only be unavailable 5 minutes and 15 seconds a year! In other words, it needs to stay up. Using Oracle 12c features, we can now keep the system available for end users through…

Oracle Database 12c introduced new capabilities for storing, indexing and querying JSON data.These capabilities allow organizations to build schemaless database models while at the same timemaintaining the full power of SQL. After a quick introduction to these capabilities, this sessionwill present examples of their usage and lessons learned from an actual application deployed to multiple…

With the release of Oracle Database 12c, new features and functionality are introduced through the Oracle Enterprise Manager 12c plug-in that are associated with the release. Learn how to manage Oracle Database 12c with Oracle Enterprise Manager 12c. In this session, you will learn what to expect with the new plug-in, how to provision pluggable…

Oracle 12c is now installed and all the new options it brings to the table, but what If you lose your primary database for a day or even an hour due to a disaster, what would the impact to your business be? Would you lose money, clients or your reputation? You might say, “I have…

DBAs have had manual systems for migrating data between storage tiers for many years. But now, Oracle Database 12c and Oracle FS Flash Storage System provide powerful new techniques. This session compares and contrasts the Automatic Data Optimization (ADO) Heat Map and Oracle FS Flash Storage System Heat Map features, and details how and when…